FINS Salesforce Marketing System API - Implementation Template
Data mappings
This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.
| Module | Description |
|---|---|
| retrieve-individul-dataextension | Salesforce Data Extension to CIM format mapping |
| subscribers-create-individual | CIM format to Salesforce create Individual request mapping |
| subscribers-create-subscriber | CIM format to Salesforce create subscriber request mapping |
| subscribers-update-subscriber | CIM format to Salesforce update data extension request mapping |
retrieve-individul-dataextension
Salesforce Data Extension to CIM format mapping
Source:
./src/main/resources/dwl/retrieve-individul-dataextension.dwl
Mapping Tables
Maps Salesforce Data Extension to CIM format
| CIM | Salesforce Data Extension | Description |
|---|---|---|
| partyType | Individual | Hardcoded party type to Individual |
| PersonName | personName | The full name of the Individual |
| id | SubscriberId | The subscriber Id |
| firstName | FirstName | The Individual first name |
| lastName | LastName | The Individual Last name |
| contactPointType | ContactPointEmail | Hardcoded contact type to ContactPointEmail |
| id | SubscriberId | The subscriber Id |
| activeFromDate | todays date | The Individual Active from date is hardcoded to todays date |
| emailAddress | EmailAddress | The Individual contact email address |
| externalIds.id | GlobalPartyId | Id field is hardcoded as empty string |
| externalIds.externalId | GlobalPartyId | The Individual Global Id |
| externalIds.externalIdType | MDM | The Global Id of Individual as in MDM that is being stored in Salesforce |
| externalIds.statusLastChangedDate | CreatedDate | created date to "yyyy-MM-dd'T'HH:mm:ssz" |
| externalIds.status | VALID | The Individual status is hardcoded as VALID |
| auditInfo.createdDate | CreatedDate | The Individual created date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.createdBy | createdBy | The last Individual created by user name |
| auditInfo.updatedDate | updatedDate | The last updated date to "yyyy-MM-dd'T'HH:mm:ssz" |
| auditInfo.updatedBy | UpdatedBy | The last modified user name |
| auditInfo.isDeleted | false | returns true if user deleted else false |
subscribers-create-individual
CIM format to Salesforce create Individual request mapping
Source:
./src/main/resources/dwl/subscribers-create-individual.dwl
Mapping Tables
Maps CIM format to Salesforce data extension Object
| Salesforce data extension Object | CIM | Description |
|---|---|---|
| concreteClassType | DataExtensionObject | Hardcoded as DataExtensionObject |
| name | Individual | Hardcoded as Individual |
| properties.property.name | EmailAddress | Hardcoded as email address |
| properties.property.value | emailAddress | The subscriber email |
| properties.property.name | GlobalPartyId | Hardcoded as global party Id |
| properties.property.value | externalId | The external Id matches MDM |
| properties.property.name | SubscriberId | Hardcoded as SubscriberId |
| properties.property.value | Id | The subscriber Id |
| properties.property.name | FirstName | Hardcoded as FirstName |
| properties.property.value | firstName | The FirstName of the Individual |
| properties.property.name | LastName | Hardcoded as LastName |
| properties.property.value | lastName | The LastName of the Individual |
| properties.property.name | PersonName | Hardcoded as PersonName |
| properties.property.value | personName | The Full name of the Individual |
| properties.property.name | CreatedDate | Hardcoded as CreatedDate |
| properties.property.value | todays date | Hardcoded today datetime to "yyyy-MM-dd HH:mm:dd" |
| properties.property.name | CreatedBy | Hardcoded as CreatedBy |
| properties.property.value | app.name | The application name |
| properties.property.name | UpdatedDate | Hardcoded as UpdatedDate |
| properties.property.value | todays date | Hardcoded today datetime to "yyyy-MM-dd HH:mm:dd" |
| properties.property.name | UpdatedBy | Hardcoded as UpdatedBy |
| properties.property.value | app.name | The application name |
subscribers-create-subscriber
CIM format to Salesforce create subscriber request mapping
Source:
./src/main/resources/dwl/subscribers-create-subscriber.dwl
Mapping Tables
Maps CIM format to Salesforce Marketing Individual subscriber mapping
| Salesforce subscriber | CIM | Description |
|---|---|---|
| CreatedDate | todays date time | The created date to now |
| EmailAddress | emailAddress | The email address of the subscriber |
| ModifiedDate | todays date time | The modified date to "yyyy-MM-dd'T'HH:mm:ssz" |
| SubscriberKey | emailAddress | The email address of the subscriber |
subscribers-update-subscriber
CIM format to Salesforce update data extension request mapping
Source:
./src/main/resources/dwl/subscribers-update-subscriber.dwl
Mapping Tables
Maps CIM format to Salesforce data extension Object
| Salesforce data extension Object | CIM | Description |
|---|---|---|
| concreteClassType | DataExtensionObject | Hardcoded as DataExtensionObject |
| name | Individual | Hardcoded as Individual |
| properties.property.name | EmailAddress | Hardcoded as email address |
| properties.property.value | emailAddress | The Individual subscriber email |
| properties.property.name | GlobalPartyId | Hardcoded as global party Id |
| properties.property.value | externalId | The external Id matches MDM |
| properties.property.name | SubscriberId | Hardcoded as SubscriberId |
| properties.property.value | Id | The subscriber id |
| properties.property.name | FirstName | Hardcoded as FirstName |
| properties.property.value | firstName | The FirstName of the Individual |
| properties.property.name | LastName | Hardcoded as LastName |
| properties.property.value | lastName | The LastName of the Individual |
| properties.property.name | PersonName | Hardcoded as PersonName |
| properties.property.value | personName | The Full name of the Individual |
| properties.property.name | CreatedDate | Hardcoded as CreatedDate |
| properties.property.value | todays date | Hardcoded today datetime to "yyyy-MM-dd HH:mm:dd" |
| properties.property.name | CreatedBy | Hardcoded as CreatedBy |
| properties.property.value | app.name | The application name |
| properties.property.name | UpdatedDate | Hardcoded as UpdatedDate |
| properties.property.value | todays date | Hardcoded today datetime to "yyyy-MM-dd HH:mm:dd" |
| properties.property.name | UpdatedBy | Hardcoded as UpdatedBy |
| properties.property.value | app.name | The application name |